UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bcS5cKdoE0FjWHr1NcKmKtFw8XljVpJoRjibdNFwXH4='
WHERE
key_id = 'ad659161feaea8bb6ad149162e4305d0f28bfb26877b19c7efb10b974f9179d2'
AND (
token = 'bcS5cKdoE0FjWHr1NcKmKtFw8XljVpJoRjibdNFwXH4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)