UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nLk+xKEgsriMQqmDZS+VP0fAglCL5HrJgtmBlchTFSQ='
WHERE
key_id = 'e97daf5c3683c81ef4ac94bd6995d697beb9856e31f94261434dd2de84660543'
AND (
token = 'nLk+xKEgsriMQqmDZS+VP0fAglCL5HrJgtmBlchTFSQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)