UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'k+GgS1hoBTlx/v3VjQ36Cr8VnAkuiposF/OAxaFuPVo='
WHERE
key_id = '1a3b1ebed953bcef0aef825d7ae1ff36cebb935295d3b5089ccd590f06df3007'
AND (
token = 'k+GgS1hoBTlx/v3VjQ36Cr8VnAkuiposF/OAxaFuPVo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)