UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gIB/1Wffrl+eKFFRNMEoYEShXL/VnDhD9jpduchP7R0='
WHERE
key_id = '678487acddc0b60ae3d72a54128f31f5afce2933ea401973bbf610a99c437b1f'
AND (
token = 'gIB/1Wffrl+eKFFRNMEoYEShXL/VnDhD9jpduchP7R0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)