UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Z6DFcJ2iykHAzN2aZ4IitPn6mPUZfo5ATaMk0F5UWXw='
WHERE
key_id = '59c6de7d7fff65e0b490a09b13e01ad473c1a009b83f395c13add900fdc92195'
AND (
token = 'Z6DFcJ2iykHAzN2aZ4IitPn6mPUZfo5ATaMk0F5UWXw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)