UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '2CIRB5Cy0ubUi6BM3z9M1txeAhxwkZfJDSq0MUWPIEU='
WHERE
key_id = '173678c518dac985df1a6b2195d0a3d2f25eb33f4b5f21fb33e4d0f2f0ae867a'
AND (
token = '2CIRB5Cy0ubUi6BM3z9M1txeAhxwkZfJDSq0MUWPIEU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)