UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'z0ZJM3h5a/zvLWXnps1MrSxvGRKuJKn/x7ephJLlgik='
WHERE
key_id = '06cd5bd9fe4d207807429767fe18d6d8237d75f6e1e4abadb3d78ae448575afa'
AND (
token = 'z0ZJM3h5a/zvLWXnps1MrSxvGRKuJKn/x7ephJLlgik='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)