UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zYBR0pEXeIWRu6UNyHIemN2hzk5cwSngjGf84tUToEE='
WHERE
key_id = '16ca9b4507c15c8ee130c851c4db63f5ebb71ec4701c9c8cdc25f44b86f627da'
AND (
token = 'zYBR0pEXeIWRu6UNyHIemN2hzk5cwSngjGf84tUToEE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)