UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4BcDk1JKsG7eCoEGUMBOIu2sFYSWTvNlexuDx5n51lg='
WHERE
key_id = 'f338d8dfad24104a767a6abcc3a55e6962a069a32091a32db6e67249442a2d6d'
AND (
token = '4BcDk1JKsG7eCoEGUMBOIu2sFYSWTvNlexuDx5n51lg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)