UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Zjy6duP3Sj9dL5l39YAILbr5H7t1dfhzbmHtWXTRwOk='
WHERE
key_id = '58e8e484b928ce3fdf155c40f7b24c4f6686048aa47ee1e96fcae63de847d7ef'
AND (
token = 'Zjy6duP3Sj9dL5l39YAILbr5H7t1dfhzbmHtWXTRwOk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)