UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HHd2nkt7cJlOHieI790+QwF731vBjD/QteKa9pJf+W4='
WHERE
key_id = '012e64849a547abdf27b7e09d99afc9afe16ca1425c43873f51396fbd6724488'
AND (
token = 'HHd2nkt7cJlOHieI790+QwF731vBjD/QteKa9pJf+W4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)