UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'x8NkYgqj48TD0gZ1Q1yJIB2S4YHCxmSzseOFQ/10Wvs='
WHERE
key_id = '1eb3b5093272171ead3bfed8cea5c497a21f7b6e13a8dfa6e3cafdceb9a31aad'
AND (
token = 'x8NkYgqj48TD0gZ1Q1yJIB2S4YHCxmSzseOFQ/10Wvs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)