UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QyFSWPnFHwQOUL+/jLZTSFNr1NH96CsCFfGpZ4nLVM0='
WHERE
key_id = '595d7a451f91f6e68194387a67695e2f83632c5c4e01cb41296b4552838e0150'
AND (
token = 'QyFSWPnFHwQOUL+/jLZTSFNr1NH96CsCFfGpZ4nLVM0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)