UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'goe9hGdWTEGS6OQdCmMhO9YHt+jKk1j7uZLvq14Gk7M='
WHERE
key_id = 'bf4efe94dbdcc51c5507e7b66046278d32f6442f163b0da0cb7a993fae649ee2'
AND (
token = 'goe9hGdWTEGS6OQdCmMhO9YHt+jKk1j7uZLvq14Gk7M='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)