UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pc76P+zMqoBUzcYoautbYSLLui8sI9ZRaLA2aibM5Ro='
WHERE
key_id = '5e1320dfd517e84b4e4930bec41651fff7e3992fe196ed85b792776a44203da1'
AND (
token = 'pc76P+zMqoBUzcYoautbYSLLui8sI9ZRaLA2aibM5Ro='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)