UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'swUvmI4cUXwCCC7JqAOI/lMh+0c89Dp3fGz6/V4Segg='
WHERE
key_id = '2ca711fd3cfc3294de6a5e8c16779aefdbcbd3defef448ddeed09949b519834e'
AND (
token = 'swUvmI4cUXwCCC7JqAOI/lMh+0c89Dp3fGz6/V4Segg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)