UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Tj9GDWEHEIc2bHuWTP1PmScL98Z8Iu45urDHjctTHu4='
WHERE
key_id = 'fd81e88b31e0844d5da37fc38e63e9f78a6614f8a867240dddeeeda967daf96a'
AND (
token = 'Tj9GDWEHEIc2bHuWTP1PmScL98Z8Iu45urDHjctTHu4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)