UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zKnLSIcJ0nE4mnOX9MUYUE+IYWhDQ75JuFdEVT9M+28='
WHERE
key_id = 'fa6735398ed0be0a4bbbc6e72a14e11c3ba82004a563ce3b14e13d24b4a707af'
AND (
token = 'zKnLSIcJ0nE4mnOX9MUYUE+IYWhDQ75JuFdEVT9M+28='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)