UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pZm3GZra07ANn4FIhUCQnByCH9C+4/aogkTrsetcQ3Y='
WHERE
key_id = '22fdd8789feb77196e4598f2a77504b47f87c91c452b50046c7a21f72a87924f'
AND (
token = 'pZm3GZra07ANn4FIhUCQnByCH9C+4/aogkTrsetcQ3Y='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)