UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ePJW97NzeWBWvJUlx8SPyxEjEC3hOIi3t6yPKZGdXQs='
WHERE
key_id = '8d7c4de8f635a842b4d06b9e7eb296b32176051e6f72b5e32487831ba7e1cee2'
AND (
token = 'ePJW97NzeWBWvJUlx8SPyxEjEC3hOIi3t6yPKZGdXQs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)