UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9mOeUUe14B3L2aV37ynS5kx+aWQnsGkEan5kxju/xAs='
WHERE
key_id = 'fdcf997eb6fc6d494ab59ee43ca3f8152bbbde1c094d1334fd13af6d1236d735'
AND (
token = '9mOeUUe14B3L2aV37ynS5kx+aWQnsGkEan5kxju/xAs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)