UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'esXCFfcWjlwDq0yU3lZ/+mzP19PKWufuPi1Lfkr3gKM='
WHERE
key_id = 'bf4e18b18ae925a923d1d71a8217281cda46573120c4078d1546630592973ce5'
AND (
token = 'esXCFfcWjlwDq0yU3lZ/+mzP19PKWufuPi1Lfkr3gKM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)