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