UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'B/HPr3WVME4jqlpxfKom30w0VUSH6GFyyaXzmNg6z2M='
WHERE
key_id = 'f639c8760a8e7695e886ef0d20678bc34a5f57c8e7820be7389afbe515f158d9'
AND (
token = 'B/HPr3WVME4jqlpxfKom30w0VUSH6GFyyaXzmNg6z2M='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)