UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tV/sNyA9Y8BwPejfdJfuW+LN6t1li//PPV2s+Iw4fOA='
WHERE
key_id = 'a8a5daad0b7f91b67d3aeb723a74a3cbc8a05739ecac01805efdf13340f38f46'
AND (
token = 'tV/sNyA9Y8BwPejfdJfuW+LN6t1li//PPV2s+Iw4fOA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)