UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'DbW3d17mg6zWQhQR1rm/6IHU1LAfoANxpomNH3g/P6E='
WHERE
key_id = '1a2e93245bde876a5f6606a87cb49cc6824624706964aefe94c94107ba6c6198'
AND (
token = 'DbW3d17mg6zWQhQR1rm/6IHU1LAfoANxpomNH3g/P6E='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)