UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'IC40sDjswBDGHT+tq1Ba78ZPpU3IsSdZ+Htz2v1OShg='
WHERE
key_id = 'e4e86ea61511fc46d77428143d519ff8d515535ec96cc41eb25c023897adf1d4'
AND (
token = 'IC40sDjswBDGHT+tq1Ba78ZPpU3IsSdZ+Htz2v1OShg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)