UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '147y6leyqyW8QzkUa2gAvSIlnimDZvTmi1+uqvwwxxA='
WHERE
key_id = 'c1ffa27d4b1b7747ffc49d7ff4d13fc10210a7ccc534296ee76fd4025f8575d6'
AND (
token = '147y6leyqyW8QzkUa2gAvSIlnimDZvTmi1+uqvwwxxA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)