UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8euoJtlNbSF6dHYdqU2KrhzBqIhWcG1b1AX2d+2lfDo='
WHERE
key_id = 'bed7b7481c45c7345cc0d137d2e53977138606dc2e3bb7d5309916145a3bb2ad'
AND (
token = '8euoJtlNbSF6dHYdqU2KrhzBqIhWcG1b1AX2d+2lfDo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)