UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tYXr1D+z6mRH8vKCIr+vogfs/1+lFD1BFaXjshMDFIU='
WHERE
key_id = 'ae2be147e827dfa1257b68d51bbb4d88ed4e2ddc0b48e9e17b596e1d12ccb3b8'
AND (
token = 'tYXr1D+z6mRH8vKCIr+vogfs/1+lFD1BFaXjshMDFIU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)