UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'eDKhTruIGmLIf6CLtQhWfhtBIOoRAsUGCy7CFMdVsr4='
WHERE
key_id = '804dc7f690895d9ed180ecef6a958f47570a0c70e404f7f2f5459546f61a111c'
AND (
token = 'eDKhTruIGmLIf6CLtQhWfhtBIOoRAsUGCy7CFMdVsr4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)