UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gzq7XMPwZ98qU8DJ9Mn2krig9In1kxL0kqYT53MBwk0='
WHERE
key_id = '6323386b24f5d86db53cab04fad7acf628b2cf1c8ba054567396868bb7c65737'
AND (
token = 'gzq7XMPwZ98qU8DJ9Mn2krig9In1kxL0kqYT53MBwk0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)