UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1gMkzH0nZXfmg8Dx7SMf3uQj52xnZH5XK/tFFsD2Erk='
WHERE
key_id = 'b50af68f59a756a28146a3736e4f14355ace751afdefb6fb45e0027fae16509a'
AND (
token = '1gMkzH0nZXfmg8Dx7SMf3uQj52xnZH5XK/tFFsD2Erk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)