UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7WAm2T68alDPvP7FR1siCQBvAo6cvC/P3iYdfeyHDO4='
WHERE
key_id = '28c78c4038a69be5aa059d924022769a80658cc9527646cd927883ea44bc27d5'
AND (
token = '7WAm2T68alDPvP7FR1siCQBvAo6cvC/P3iYdfeyHDO4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)