UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZszLlpOCeOSqJAKByFXLoF7FBZfsmuT+FdWH+kzKUNs='
WHERE
key_id = '94e113ba282b7ec71df317fe2fcf6fc07225f5922d12b44a0560de3f8718ac89'
AND (
token = 'ZszLlpOCeOSqJAKByFXLoF7FBZfsmuT+FdWH+kzKUNs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)